Creating four Line and Stacked Column Charts
16

Attrition by Department - Line and Stacked Column Chart:

1. Chart Configuration:
- Set the X-axis to "Department".
- For
the Column Y-axis, use the count of ‘Status’. The ‘Status’ is a
calculated field derived from the ‘Left’ field, where 0 indicates
'Employed' and 1 indicates 'Left' (departure from the company).
- Set
the Line Y-axis to display the ‘Attrition %’ and ‘Satisfaction %’
measures. Ensure both are formatted as percentages with 0 decimal
places.
- Set the legend to ‘Status’ again for clarity and cohesiveness with the data represented.
2. Chart Dimensions and Placement:
Select the "Line and Stacked Column Chart" from the Visualizations
pane. Set the height and width to 301x344. Position the chart at
Horizontal: 181 and Vertical: 86 on your dashboard.
3. Formatting:
- Edit the chart title to ‘Attrition by Department’ using DIN font, size 14, color black, and background color #C7D4E8.
- Enable the legend but disable the legend title for a cleaner look.
- Disable the chart background to maintain focus on the data.
- Enable a visual border with the color #999999.
- Configure
X-axis and Y-axis values with Segoe font, size 9, and color black.
Disable titles for both axes to simplify the visual presentation.
- Turn off all gridlines for a neater chart appearance.
- Sort the legend (Status) in descending order for intuitive data comprehension.
- Customize the column colors: set ‘Left’ to #41A4FF and ‘Employed’ to #4E79A7.
- Adjust
the line stroke width to 3x for visibility. Set the line color for
‘Attrition %’ to #C5A00C and for ‘Satisfaction %’ to #4AC7B0 for
distinct recognition.
4. Replicate for Additional Metrics:
Copy the created chart and adjust the X-axis field to generate new
charts: 'Attrition by Tenure', 'Attrition by Number of Projects', and
'Attrition by Salary', adapting each for distinct attrition insights.
5. Create Line and Stacked Column Charts for Predictive Section:
Following the same process, develop four corresponding Line and Stacked
Column Charts for the predictive section, selecting appropriate
predictive measures and metrics for each chart. Ensure these also follow
the formatting standards and color schemes established in the
historical section for consistency.
6. Managing Visibility for Sections:
- In
the predictive section of the dashboard, select all historical charts
and hide them using the Selection Pane. Then, update the predictive
bookmark to save this state where only predictive charts are visible.
- Conversely,
in the historical section, hide all predictive charts through the
Selection Pane and update the historical bookmark to reflect this setup,
ensuring only historical charts display in this view. Finally, toggle
between the historical and predictive bookmarks to verify the correct
functionality and visibility of the charts.



Line and Stacked Column Chart in Power B